﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using JKF.DataModule.SqlServerDAL;
using System.Data;

namespace JKF.BusinessLayer.BLL
{
   public partial class bllSTOCK_OUT
    {
       /// <summary>
        ///  从视图 dbo.V_PRODUCT_STOCK_OUT 获取入库时数据列表
        /// </summary>
        /// <param name="shop_code">当前用户所属店面</param>
        /// <param name="NAME">产品名称</param>
        /// <param name="TYPE">产品类别</param>
        /// <param name="PRODUCT_NUMS">出库数量</param>
        /// <param name="IN_NO">入库单号</param>
        /// <param name="REAL_NAME">操作员姓名</param>
        /// <param name="MEMO">备注</param>
        /// <param name="DATE_START">出库开始日期</param>
        /// <param name="DATE_END">出库结束日期</param>
        /// <param name="pageCurrent">当前页码</param>
        /// <param name="pageSize">一页显示多少条数据</param>
        /// <param name="pageCount">总页数</param>
        /// <param name="rowCount">总记录数</param>
        /// <returns>返回DataTable数据集</returns>
       public DataTable GetStock_OutsBLL(string NAME, string shop_code, string product_key, string PRODUCT_NUMS, string OUT_NO, string REAL_NAME, string MEMO, string DATE_START, string DATE_END, int pageCurrent, int pageSize, ref int pageCount, ref int rowCount)
       {
           return dalSTOCK_OUT.GetStock_OutsDAL(NAME,shop_code, product_key, PRODUCT_NUMS, OUT_NO, REAL_NAME, MEMO, DATE_START, DATE_END, pageCurrent, pageSize,ref pageCount, ref rowCount);
       }
	   
        /// <summary>
        /// 事务执行SQL语句
        /// </summary>
        /// <returns></returns>
        public bool TransationSql(string sql)
        {
            return dalSTOCK_IN.TransationSql(sql);
        }
        /// <summary>
        /// 根据当前店铺编码获取其入库单号
        /// </summary>
        /// <param name="shop_code"></param>
        /// <returns></returns>
       public  string GetStock_OUT_NOBLL(string shop_code)
       {
           return dalSTOCK_OUT.GetStock_OUT_NODAL(shop_code);
       }
    }
}
